<%-- 
    Document   : tasksprocess
    Created on : 9 Apr, 2010, 3:26:21 PM
    Author     : Praveen Kumar
--%>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.sql.*"%>
<%@page language="java" import="java.util.*"%>



<%

            Connection connection = null;
            try {

                String driverName = "oracle.jdbc.driver.OracleDriver";
                Class.forName(driverName);

                // Create a connection to the database
                String serverName = "10.0.0.27";
                String portNumber = "1521";
                String sid = "XE";
                String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
                String uname = "aranya27";
                String pword = "doodledo";

                connection = DriverManager.getConnection(url, uname, pword);



              // enter code here

                Statement st = null;

                st = connection.createStatement();

                String str = "update begin_allot set allot=current_timestamp";
                ResultSet rs = st.executeQuery(str);


                connection.close();


                //end here

            } catch (ClassNotFoundException e) {
                e.printStackTrace();
                System.out.println(" Could not find the database driver");
            } catch (SQLException e) {
                e.printStackTrace();
                System.out.println("Could not connect to the database");
            }



%>
<%response.sendRedirect("totalstudDetails.jsp");%>